using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;
namespace CXDB{
    /// <summary>
    /// Strongly-typed collection for the VwCompanyPingjium class.
    /// </summary>
    [Serializable]
    public partial class VwCompanyPingjiumCollection : ReadOnlyList<VwCompanyPingjium, VwCompanyPingjiumCollection>
    {        
        public VwCompanyPingjiumCollection() {}
    }
    /// <summary>
    /// This is  Read-only wrapper class for the vw_company_pingjia view.
    /// </summary>
    [Serializable]
    public partial class VwCompanyPingjium : ReadOnlyRecord<VwCompanyPingjium>, IReadOnlyRecord
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }
	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }
                return BaseSchema;
            }
        }
    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vw_company_pingjia", TableType.View, DataService.GetInstance("CXDB"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = @"dbo";
                //columns
                
                TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema);
                colvarId.ColumnName = "ID";
                colvarId.DataType = DbType.Int32;
                colvarId.MaxLength = 0;
                colvarId.AutoIncrement = false;
                colvarId.IsNullable = false;
                colvarId.IsPrimaryKey = false;
                colvarId.IsForeignKey = false;
                colvarId.IsReadOnly = false;
                
                schema.Columns.Add(colvarId);
                
                TableSchema.TableColumn colvarCompanyID = new TableSchema.TableColumn(schema);
                colvarCompanyID.ColumnName = "CompanyID";
                colvarCompanyID.DataType = DbType.AnsiStringFixedLength;
                colvarCompanyID.MaxLength = 100;
                colvarCompanyID.AutoIncrement = false;
                colvarCompanyID.IsNullable = true;
                colvarCompanyID.IsPrimaryKey = false;
                colvarCompanyID.IsForeignKey = false;
                colvarCompanyID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCompanyID);
                
                TableSchema.TableColumn colvarCompanyName = new TableSchema.TableColumn(schema);
                colvarCompanyName.ColumnName = "CompanyName";
                colvarCompanyName.DataType = DbType.String;
                colvarCompanyName.MaxLength = 100;
                colvarCompanyName.AutoIncrement = false;
                colvarCompanyName.IsNullable = true;
                colvarCompanyName.IsPrimaryKey = false;
                colvarCompanyName.IsForeignKey = false;
                colvarCompanyName.IsReadOnly = false;
                
                schema.Columns.Add(colvarCompanyName);
                
                TableSchema.TableColumn colvarUnFeeTime = new TableSchema.TableColumn(schema);
                colvarUnFeeTime.ColumnName = "unFee_time";
                colvarUnFeeTime.DataType = DbType.DateTime;
                colvarUnFeeTime.MaxLength = 0;
                colvarUnFeeTime.AutoIncrement = false;
                colvarUnFeeTime.IsNullable = true;
                colvarUnFeeTime.IsPrimaryKey = false;
                colvarUnFeeTime.IsForeignKey = false;
                colvarUnFeeTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnFeeTime);
                
                TableSchema.TableColumn colvarUnFeeCash = new TableSchema.TableColumn(schema);
                colvarUnFeeCash.ColumnName = "unFee_Cash";
                colvarUnFeeCash.DataType = DbType.Int32;
                colvarUnFeeCash.MaxLength = 0;
                colvarUnFeeCash.AutoIncrement = false;
                colvarUnFeeCash.IsNullable = true;
                colvarUnFeeCash.IsPrimaryKey = false;
                colvarUnFeeCash.IsForeignKey = false;
                colvarUnFeeCash.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnFeeCash);
                
                TableSchema.TableColumn colvarUnFeeDetail = new TableSchema.TableColumn(schema);
                colvarUnFeeDetail.ColumnName = "unFee_Detail";
                colvarUnFeeDetail.DataType = DbType.String;
                colvarUnFeeDetail.MaxLength = 1073741823;
                colvarUnFeeDetail.AutoIncrement = false;
                colvarUnFeeDetail.IsNullable = true;
                colvarUnFeeDetail.IsPrimaryKey = false;
                colvarUnFeeDetail.IsForeignKey = false;
                colvarUnFeeDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnFeeDetail);
                
                TableSchema.TableColumn colvarThiefTime1 = new TableSchema.TableColumn(schema);
                colvarThiefTime1.ColumnName = "thief_Time1";
                colvarThiefTime1.DataType = DbType.DateTime;
                colvarThiefTime1.MaxLength = 0;
                colvarThiefTime1.AutoIncrement = false;
                colvarThiefTime1.IsNullable = true;
                colvarThiefTime1.IsPrimaryKey = false;
                colvarThiefTime1.IsForeignKey = false;
                colvarThiefTime1.IsReadOnly = false;
                
                schema.Columns.Add(colvarThiefTime1);
                
                TableSchema.TableColumn colvarThiefTime2 = new TableSchema.TableColumn(schema);
                colvarThiefTime2.ColumnName = "thief_Time2";
                colvarThiefTime2.DataType = DbType.DateTime;
                colvarThiefTime2.MaxLength = 0;
                colvarThiefTime2.AutoIncrement = false;
                colvarThiefTime2.IsNullable = true;
                colvarThiefTime2.IsPrimaryKey = false;
                colvarThiefTime2.IsForeignKey = false;
                colvarThiefTime2.IsReadOnly = false;
                
                schema.Columns.Add(colvarThiefTime2);
                
                TableSchema.TableColumn colvarThiefCash = new TableSchema.TableColumn(schema);
                colvarThiefCash.ColumnName = "thief_Cash";
                colvarThiefCash.DataType = DbType.Int32;
                colvarThiefCash.MaxLength = 0;
                colvarThiefCash.AutoIncrement = false;
                colvarThiefCash.IsNullable = true;
                colvarThiefCash.IsPrimaryKey = false;
                colvarThiefCash.IsForeignKey = false;
                colvarThiefCash.IsReadOnly = false;
                
                schema.Columns.Add(colvarThiefCash);
                
                TableSchema.TableColumn colvarThiefDetail = new TableSchema.TableColumn(schema);
                colvarThiefDetail.ColumnName = "thief_Detail";
                colvarThiefDetail.DataType = DbType.String;
                colvarThiefDetail.MaxLength = 1073741823;
                colvarThiefDetail.AutoIncrement = false;
                colvarThiefDetail.IsNullable = true;
                colvarThiefDetail.IsPrimaryKey = false;
                colvarThiefDetail.IsForeignKey = false;
                colvarThiefDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarThiefDetail);
                
                TableSchema.TableColumn colvarUnCoopPeakTime = new TableSchema.TableColumn(schema);
                colvarUnCoopPeakTime.ColumnName = "unCoop_Peak_time";
                colvarUnCoopPeakTime.DataType = DbType.DateTime;
                colvarUnCoopPeakTime.MaxLength = 0;
                colvarUnCoopPeakTime.AutoIncrement = false;
                colvarUnCoopPeakTime.IsNullable = true;
                colvarUnCoopPeakTime.IsPrimaryKey = false;
                colvarUnCoopPeakTime.IsForeignKey = false;
                colvarUnCoopPeakTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnCoopPeakTime);
                
                TableSchema.TableColumn colvarUnCoopPeakDetail = new TableSchema.TableColumn(schema);
                colvarUnCoopPeakDetail.ColumnName = "unCoop_Peak_Detail";
                colvarUnCoopPeakDetail.DataType = DbType.String;
                colvarUnCoopPeakDetail.MaxLength = 1073741823;
                colvarUnCoopPeakDetail.AutoIncrement = false;
                colvarUnCoopPeakDetail.IsNullable = true;
                colvarUnCoopPeakDetail.IsPrimaryKey = false;
                colvarUnCoopPeakDetail.IsForeignKey = false;
                colvarUnCoopPeakDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnCoopPeakDetail);
                
                TableSchema.TableColumn colvarUnCoopLimitTime = new TableSchema.TableColumn(schema);
                colvarUnCoopLimitTime.ColumnName = "unCoop_Limit_time";
                colvarUnCoopLimitTime.DataType = DbType.DateTime;
                colvarUnCoopLimitTime.MaxLength = 0;
                colvarUnCoopLimitTime.AutoIncrement = false;
                colvarUnCoopLimitTime.IsNullable = true;
                colvarUnCoopLimitTime.IsPrimaryKey = false;
                colvarUnCoopLimitTime.IsForeignKey = false;
                colvarUnCoopLimitTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnCoopLimitTime);
                
                TableSchema.TableColumn colvarUnCoopLimitDetail = new TableSchema.TableColumn(schema);
                colvarUnCoopLimitDetail.ColumnName = "unCoop_Limit_Detail";
                colvarUnCoopLimitDetail.DataType = DbType.String;
                colvarUnCoopLimitDetail.MaxLength = 1073741823;
                colvarUnCoopLimitDetail.AutoIncrement = false;
                colvarUnCoopLimitDetail.IsNullable = true;
                colvarUnCoopLimitDetail.IsPrimaryKey = false;
                colvarUnCoopLimitDetail.IsForeignKey = false;
                colvarUnCoopLimitDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnCoopLimitDetail);
                
                TableSchema.TableColumn colvarUnCoopOthers = new TableSchema.TableColumn(schema);
                colvarUnCoopOthers.ColumnName = "unCoop_Others";
                colvarUnCoopOthers.DataType = DbType.String;
                colvarUnCoopOthers.MaxLength = 1073741823;
                colvarUnCoopOthers.AutoIncrement = false;
                colvarUnCoopOthers.IsNullable = true;
                colvarUnCoopOthers.IsPrimaryKey = false;
                colvarUnCoopOthers.IsForeignKey = false;
                colvarUnCoopOthers.IsReadOnly = false;
                
                schema.Columns.Add(colvarUnCoopOthers);
                
                TableSchema.TableColumn colvarEnterUserId = new TableSchema.TableColumn(schema);
                colvarEnterUserId.ColumnName = "Enter_user_ID";
                colvarEnterUserId.DataType = DbType.Int32;
                colvarEnterUserId.MaxLength = 0;
                colvarEnterUserId.AutoIncrement = false;
                colvarEnterUserId.IsNullable = true;
                colvarEnterUserId.IsPrimaryKey = false;
                colvarEnterUserId.IsForeignKey = false;
                colvarEnterUserId.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnterUserId);
                
                TableSchema.TableColumn colvarDeptMasterId = new TableSchema.TableColumn(schema);
                colvarDeptMasterId.ColumnName = "Dept_Master_ID";
                colvarDeptMasterId.DataType = DbType.Int32;
                colvarDeptMasterId.MaxLength = 0;
                colvarDeptMasterId.AutoIncrement = false;
                colvarDeptMasterId.IsNullable = true;
                colvarDeptMasterId.IsPrimaryKey = false;
                colvarDeptMasterId.IsForeignKey = false;
                colvarDeptMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterId);
                
                TableSchema.TableColumn colvarDeptMasterRemark = new TableSchema.TableColumn(schema);
                colvarDeptMasterRemark.ColumnName = "Dept_Master_Remark";
                colvarDeptMasterRemark.DataType = DbType.String;
                colvarDeptMasterRemark.MaxLength = 1073741823;
                colvarDeptMasterRemark.AutoIncrement = false;
                colvarDeptMasterRemark.IsNullable = true;
                colvarDeptMasterRemark.IsPrimaryKey = false;
                colvarDeptMasterRemark.IsForeignKey = false;
                colvarDeptMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterRemark);
                
                TableSchema.TableColumn colvarDeptMasterStatus = new TableSchema.TableColumn(schema);
                colvarDeptMasterStatus.ColumnName = "Dept_Master_status";
                colvarDeptMasterStatus.DataType = DbType.Int32;
                colvarDeptMasterStatus.MaxLength = 0;
                colvarDeptMasterStatus.AutoIncrement = false;
                colvarDeptMasterStatus.IsNullable = true;
                colvarDeptMasterStatus.IsPrimaryKey = false;
                colvarDeptMasterStatus.IsForeignKey = false;
                colvarDeptMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterStatus);
                
                TableSchema.TableColumn colvarDeptMasterEnteringTime = new TableSchema.TableColumn(schema);
                colvarDeptMasterEnteringTime.ColumnName = "Dept_Master_Entering_time";
                colvarDeptMasterEnteringTime.DataType = DbType.DateTime;
                colvarDeptMasterEnteringTime.MaxLength = 0;
                colvarDeptMasterEnteringTime.AutoIncrement = false;
                colvarDeptMasterEnteringTime.IsNullable = true;
                colvarDeptMasterEnteringTime.IsPrimaryKey = false;
                colvarDeptMasterEnteringTime.IsForeignKey = false;
                colvarDeptMasterEnteringTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterEnteringTime);
                
                TableSchema.TableColumn colvarManagerId = new TableSchema.TableColumn(schema);
                colvarManagerId.ColumnName = "Manager_ID";
                colvarManagerId.DataType = DbType.Int32;
                colvarManagerId.MaxLength = 0;
                colvarManagerId.AutoIncrement = false;
                colvarManagerId.IsNullable = true;
                colvarManagerId.IsPrimaryKey = false;
                colvarManagerId.IsForeignKey = false;
                colvarManagerId.IsReadOnly = false;
                
                schema.Columns.Add(colvarManagerId);
                
                TableSchema.TableColumn colvarManagerStatus = new TableSchema.TableColumn(schema);
                colvarManagerStatus.ColumnName = "Manager_Status";
                colvarManagerStatus.DataType = DbType.Int32;
                colvarManagerStatus.MaxLength = 0;
                colvarManagerStatus.AutoIncrement = false;
                colvarManagerStatus.IsNullable = true;
                colvarManagerStatus.IsPrimaryKey = false;
                colvarManagerStatus.IsForeignKey = false;
                colvarManagerStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarManagerStatus);
                
                TableSchema.TableColumn colvarManagerRemark = new TableSchema.TableColumn(schema);
                colvarManagerRemark.ColumnName = "Manager_Remark";
                colvarManagerRemark.DataType = DbType.String;
                colvarManagerRemark.MaxLength = 1073741823;
                colvarManagerRemark.AutoIncrement = false;
                colvarManagerRemark.IsNullable = true;
                colvarManagerRemark.IsPrimaryKey = false;
                colvarManagerRemark.IsForeignKey = false;
                colvarManagerRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarManagerRemark);
                
                TableSchema.TableColumn colvarManagerRemarkTime = new TableSchema.TableColumn(schema);
                colvarManagerRemarkTime.ColumnName = "Manager_Remark_time";
                colvarManagerRemarkTime.DataType = DbType.DateTime;
                colvarManagerRemarkTime.MaxLength = 0;
                colvarManagerRemarkTime.AutoIncrement = false;
                colvarManagerRemarkTime.IsNullable = true;
                colvarManagerRemarkTime.IsPrimaryKey = false;
                colvarManagerRemarkTime.IsForeignKey = false;
                colvarManagerRemarkTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarManagerRemarkTime);
                
                TableSchema.TableColumn colvarInTime = new TableSchema.TableColumn(schema);
                colvarInTime.ColumnName = "inTime";
                colvarInTime.DataType = DbType.DateTime;
                colvarInTime.MaxLength = 0;
                colvarInTime.AutoIncrement = false;
                colvarInTime.IsNullable = true;
                colvarInTime.IsPrimaryKey = false;
                colvarInTime.IsForeignKey = false;
                colvarInTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarInTime);
                
                TableSchema.TableColumn colvarStatus = new TableSchema.TableColumn(schema);
                colvarStatus.ColumnName = "Status";
                colvarStatus.DataType = DbType.Int32;
                colvarStatus.MaxLength = 0;
                colvarStatus.AutoIncrement = false;
                colvarStatus.IsNullable = true;
                colvarStatus.IsPrimaryKey = false;
                colvarStatus.IsForeignKey = false;
                colvarStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarStatus);
                
                TableSchema.TableColumn colvarGuid = new TableSchema.TableColumn(schema);
                colvarGuid.ColumnName = "Guid";
                colvarGuid.DataType = DbType.Guid;
                colvarGuid.MaxLength = 0;
                colvarGuid.AutoIncrement = false;
                colvarGuid.IsNullable = true;
                colvarGuid.IsPrimaryKey = false;
                colvarGuid.IsForeignKey = false;
                colvarGuid.IsReadOnly = false;
                
                schema.Columns.Add(colvarGuid);
                
                TableSchema.TableColumn colvarEnterUsername = new TableSchema.TableColumn(schema);
                colvarEnterUsername.ColumnName = "enter_username";
                colvarEnterUsername.DataType = DbType.String;
                colvarEnterUsername.MaxLength = 50;
                colvarEnterUsername.AutoIncrement = false;
                colvarEnterUsername.IsNullable = true;
                colvarEnterUsername.IsPrimaryKey = false;
                colvarEnterUsername.IsForeignKey = false;
                colvarEnterUsername.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnterUsername);
                
                TableSchema.TableColumn colvarEnterDeptname = new TableSchema.TableColumn(schema);
                colvarEnterDeptname.ColumnName = "enter_deptname";
                colvarEnterDeptname.DataType = DbType.String;
                colvarEnterDeptname.MaxLength = 50;
                colvarEnterDeptname.AutoIncrement = false;
                colvarEnterDeptname.IsNullable = true;
                colvarEnterDeptname.IsPrimaryKey = false;
                colvarEnterDeptname.IsForeignKey = false;
                colvarEnterDeptname.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnterDeptname);
                
                TableSchema.TableColumn colvarOtherMasterId = new TableSchema.TableColumn(schema);
                colvarOtherMasterId.ColumnName = "other_master_id";
                colvarOtherMasterId.DataType = DbType.Int32;
                colvarOtherMasterId.MaxLength = 0;
                colvarOtherMasterId.AutoIncrement = false;
                colvarOtherMasterId.IsNullable = true;
                colvarOtherMasterId.IsPrimaryKey = false;
                colvarOtherMasterId.IsForeignKey = false;
                colvarOtherMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherMasterId);
                
                TableSchema.TableColumn colvarOtherMasterTime = new TableSchema.TableColumn(schema);
                colvarOtherMasterTime.ColumnName = "other_master_time";
                colvarOtherMasterTime.DataType = DbType.DateTime;
                colvarOtherMasterTime.MaxLength = 0;
                colvarOtherMasterTime.AutoIncrement = false;
                colvarOtherMasterTime.IsNullable = true;
                colvarOtherMasterTime.IsPrimaryKey = false;
                colvarOtherMasterTime.IsForeignKey = false;
                colvarOtherMasterTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherMasterTime);
                
                TableSchema.TableColumn colvarOtherMasterStatus = new TableSchema.TableColumn(schema);
                colvarOtherMasterStatus.ColumnName = "other_master_status";
                colvarOtherMasterStatus.DataType = DbType.Int32;
                colvarOtherMasterStatus.MaxLength = 0;
                colvarOtherMasterStatus.AutoIncrement = false;
                colvarOtherMasterStatus.IsNullable = true;
                colvarOtherMasterStatus.IsPrimaryKey = false;
                colvarOtherMasterStatus.IsForeignKey = false;
                colvarOtherMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherMasterStatus);
                
                TableSchema.TableColumn colvarOtherMasterRemark = new TableSchema.TableColumn(schema);
                colvarOtherMasterRemark.ColumnName = "other_master_remark";
                colvarOtherMasterRemark.DataType = DbType.String;
                colvarOtherMasterRemark.MaxLength = 1073741823;
                colvarOtherMasterRemark.AutoIncrement = false;
                colvarOtherMasterRemark.IsNullable = true;
                colvarOtherMasterRemark.IsPrimaryKey = false;
                colvarOtherMasterRemark.IsForeignKey = false;
                colvarOtherMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherMasterRemark);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["CXDB"].AddSchema("vw_company_pingjia",schema);
            }
        }
        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }
	    #endregion
	    
	    #region .ctors
	    public VwCompanyPingjium()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }
        public VwCompanyPingjium(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}
			MarkNew();
	    }
	    
	    public VwCompanyPingjium(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }
    	 
	    public VwCompanyPingjium(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }
        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("Id")]
        [Bindable(true)]
        public int Id 
	    {
		    get
		    {
			    return GetColumnValue<int>("ID");
		    }
            set 
		    {
			    SetColumnValue("ID", value);
            }
        }
	      
        [XmlAttribute("CompanyID")]
        [Bindable(true)]
        public string CompanyID 
	    {
		    get
		    {
			    return GetColumnValue<string>("CompanyID");
		    }
            set 
		    {
			    SetColumnValue("CompanyID", value);
            }
        }
	      
        [XmlAttribute("CompanyName")]
        [Bindable(true)]
        public string CompanyName 
	    {
		    get
		    {
			    return GetColumnValue<string>("CompanyName");
		    }
            set 
		    {
			    SetColumnValue("CompanyName", value);
            }
        }
	      
        [XmlAttribute("UnFeeTime")]
        [Bindable(true)]
        public DateTime? UnFeeTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("unFee_time");
		    }
            set 
		    {
			    SetColumnValue("unFee_time", value);
            }
        }
	      
        [XmlAttribute("UnFeeCash")]
        [Bindable(true)]
        public int? UnFeeCash 
	    {
		    get
		    {
			    return GetColumnValue<int?>("unFee_Cash");
		    }
            set 
		    {
			    SetColumnValue("unFee_Cash", value);
            }
        }
	      
        [XmlAttribute("UnFeeDetail")]
        [Bindable(true)]
        public string UnFeeDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("unFee_Detail");
		    }
            set 
		    {
			    SetColumnValue("unFee_Detail", value);
            }
        }
	      
        [XmlAttribute("ThiefTime1")]
        [Bindable(true)]
        public DateTime? ThiefTime1 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("thief_Time1");
		    }
            set 
		    {
			    SetColumnValue("thief_Time1", value);
            }
        }
	      
        [XmlAttribute("ThiefTime2")]
        [Bindable(true)]
        public DateTime? ThiefTime2 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("thief_Time2");
		    }
            set 
		    {
			    SetColumnValue("thief_Time2", value);
            }
        }
	      
        [XmlAttribute("ThiefCash")]
        [Bindable(true)]
        public int? ThiefCash 
	    {
		    get
		    {
			    return GetColumnValue<int?>("thief_Cash");
		    }
            set 
		    {
			    SetColumnValue("thief_Cash", value);
            }
        }
	      
        [XmlAttribute("ThiefDetail")]
        [Bindable(true)]
        public string ThiefDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("thief_Detail");
		    }
            set 
		    {
			    SetColumnValue("thief_Detail", value);
            }
        }
	      
        [XmlAttribute("UnCoopPeakTime")]
        [Bindable(true)]
        public DateTime? UnCoopPeakTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("unCoop_Peak_time");
		    }
            set 
		    {
			    SetColumnValue("unCoop_Peak_time", value);
            }
        }
	      
        [XmlAttribute("UnCoopPeakDetail")]
        [Bindable(true)]
        public string UnCoopPeakDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("unCoop_Peak_Detail");
		    }
            set 
		    {
			    SetColumnValue("unCoop_Peak_Detail", value);
            }
        }
	      
        [XmlAttribute("UnCoopLimitTime")]
        [Bindable(true)]
        public DateTime? UnCoopLimitTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("unCoop_Limit_time");
		    }
            set 
		    {
			    SetColumnValue("unCoop_Limit_time", value);
            }
        }
	      
        [XmlAttribute("UnCoopLimitDetail")]
        [Bindable(true)]
        public string UnCoopLimitDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("unCoop_Limit_Detail");
		    }
            set 
		    {
			    SetColumnValue("unCoop_Limit_Detail", value);
            }
        }
	      
        [XmlAttribute("UnCoopOthers")]
        [Bindable(true)]
        public string UnCoopOthers 
	    {
		    get
		    {
			    return GetColumnValue<string>("unCoop_Others");
		    }
            set 
		    {
			    SetColumnValue("unCoop_Others", value);
            }
        }
	      
        [XmlAttribute("EnterUserId")]
        [Bindable(true)]
        public int? EnterUserId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Enter_user_ID");
		    }
            set 
		    {
			    SetColumnValue("Enter_user_ID", value);
            }
        }
	      
        [XmlAttribute("DeptMasterId")]
        [Bindable(true)]
        public int? DeptMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_Master_ID");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_ID", value);
            }
        }
	      
        [XmlAttribute("DeptMasterRemark")]
        [Bindable(true)]
        public string DeptMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Dept_Master_Remark");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_Remark", value);
            }
        }
	      
        [XmlAttribute("DeptMasterStatus")]
        [Bindable(true)]
        public int? DeptMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_Master_status");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_status", value);
            }
        }
	      
        [XmlAttribute("DeptMasterEnteringTime")]
        [Bindable(true)]
        public DateTime? DeptMasterEnteringTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Dept_Master_Entering_time");
		    }
            set 
		    {
			    SetColumnValue("Dept_Master_Entering_time", value);
            }
        }
	      
        [XmlAttribute("ManagerId")]
        [Bindable(true)]
        public int? ManagerId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Manager_ID");
		    }
            set 
		    {
			    SetColumnValue("Manager_ID", value);
            }
        }
	      
        [XmlAttribute("ManagerStatus")]
        [Bindable(true)]
        public int? ManagerStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Manager_Status");
		    }
            set 
		    {
			    SetColumnValue("Manager_Status", value);
            }
        }
	      
        [XmlAttribute("ManagerRemark")]
        [Bindable(true)]
        public string ManagerRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Manager_Remark");
		    }
            set 
		    {
			    SetColumnValue("Manager_Remark", value);
            }
        }
	      
        [XmlAttribute("ManagerRemarkTime")]
        [Bindable(true)]
        public DateTime? ManagerRemarkTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Manager_Remark_time");
		    }
            set 
		    {
			    SetColumnValue("Manager_Remark_time", value);
            }
        }
	      
        [XmlAttribute("InTime")]
        [Bindable(true)]
        public DateTime? InTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("inTime");
		    }
            set 
		    {
			    SetColumnValue("inTime", value);
            }
        }
	      
        [XmlAttribute("Status")]
        [Bindable(true)]
        public int? Status 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Status");
		    }
            set 
		    {
			    SetColumnValue("Status", value);
            }
        }
	      
        [XmlAttribute("Guid")]
        [Bindable(true)]
        public Guid? Guid 
	    {
		    get
		    {
			    return GetColumnValue<Guid?>("Guid");
		    }
            set 
		    {
			    SetColumnValue("Guid", value);
            }
        }
	      
        [XmlAttribute("EnterUsername")]
        [Bindable(true)]
        public string EnterUsername 
	    {
		    get
		    {
			    return GetColumnValue<string>("enter_username");
		    }
            set 
		    {
			    SetColumnValue("enter_username", value);
            }
        }
	      
        [XmlAttribute("EnterDeptname")]
        [Bindable(true)]
        public string EnterDeptname 
	    {
		    get
		    {
			    return GetColumnValue<string>("enter_deptname");
		    }
            set 
		    {
			    SetColumnValue("enter_deptname", value);
            }
        }
	      
        [XmlAttribute("OtherMasterId")]
        [Bindable(true)]
        public int? OtherMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("other_master_id");
		    }
            set 
		    {
			    SetColumnValue("other_master_id", value);
            }
        }
	      
        [XmlAttribute("OtherMasterTime")]
        [Bindable(true)]
        public DateTime? OtherMasterTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("other_master_time");
		    }
            set 
		    {
			    SetColumnValue("other_master_time", value);
            }
        }
	      
        [XmlAttribute("OtherMasterStatus")]
        [Bindable(true)]
        public int? OtherMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("other_master_status");
		    }
            set 
		    {
			    SetColumnValue("other_master_status", value);
            }
        }
	      
        [XmlAttribute("OtherMasterRemark")]
        [Bindable(true)]
        public string OtherMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("other_master_remark");
		    }
            set 
		    {
			    SetColumnValue("other_master_remark", value);
            }
        }
	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string Id = @"ID";
            
            public static string CompanyID = @"CompanyID";
            
            public static string CompanyName = @"CompanyName";
            
            public static string UnFeeTime = @"unFee_time";
            
            public static string UnFeeCash = @"unFee_Cash";
            
            public static string UnFeeDetail = @"unFee_Detail";
            
            public static string ThiefTime1 = @"thief_Time1";
            
            public static string ThiefTime2 = @"thief_Time2";
            
            public static string ThiefCash = @"thief_Cash";
            
            public static string ThiefDetail = @"thief_Detail";
            
            public static string UnCoopPeakTime = @"unCoop_Peak_time";
            
            public static string UnCoopPeakDetail = @"unCoop_Peak_Detail";
            
            public static string UnCoopLimitTime = @"unCoop_Limit_time";
            
            public static string UnCoopLimitDetail = @"unCoop_Limit_Detail";
            
            public static string UnCoopOthers = @"unCoop_Others";
            
            public static string EnterUserId = @"Enter_user_ID";
            
            public static string DeptMasterId = @"Dept_Master_ID";
            
            public static string DeptMasterRemark = @"Dept_Master_Remark";
            
            public static string DeptMasterStatus = @"Dept_Master_status";
            
            public static string DeptMasterEnteringTime = @"Dept_Master_Entering_time";
            
            public static string ManagerId = @"Manager_ID";
            
            public static string ManagerStatus = @"Manager_Status";
            
            public static string ManagerRemark = @"Manager_Remark";
            
            public static string ManagerRemarkTime = @"Manager_Remark_time";
            
            public static string InTime = @"inTime";
            
            public static string Status = @"Status";
            
            public static string Guid = @"Guid";
            
            public static string EnterUsername = @"enter_username";
            
            public static string EnterDeptname = @"enter_deptname";
            
            public static string OtherMasterId = @"other_master_id";
            
            public static string OtherMasterTime = @"other_master_time";
            
            public static string OtherMasterStatus = @"other_master_status";
            
            public static string OtherMasterRemark = @"other_master_remark";
            
	    }
	    #endregion
	    
	    
	    #region IAbstractRecord Members
        public new CT GetColumnValue<CT>(string columnName) {
            return base.GetColumnValue<CT>(columnName);
        }
        public object GetColumnValue(string columnName) {
            return base.GetColumnValue<object>(columnName);
        }
        #endregion
	    
    }
}
